<?php
require_once("Connections/local.php"); // database connection

// Retrieve data from Query String
$trn = $_GET['trn'];

// query
$query = "SELECT * FROM  cert_reqs WHERE cert_reqs.trn = '$trn' ORDER BY 3 DESC" ;

// execute query 
$result 		= @mysql_query($query); 

// check result number
if (mysql_num_rows($result) == 0) {
    // print empty table and exit
}

// fetch results
$row_reqs		= mysql_fetch_assoc($result);

// table def and header
echo '<table width="630" border="0">' ;

// print results
 do { 
     
	
	echo '<tr><td width="170">Course Pre-Requisites</td><td width="251">&nbsp;</td><td width="195">&nbsp;</td></tr>' ;
	 
	 
 } while ($row_reqs = mysql_fetch_assoc($result));

echo '</table>' ;

?>